SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE dbo.DnnProduct_UpdateModulePermission
	@ModulePermissionID		int, 
	@ModuleID				int, 
	@PermissionID			int, 
	@RoleID					int ,
	@AllowAccess			bit,
	@LastModifiedByUserID	int

AS

UPDATE dbo.DnnProduct_ModulePermission SET
	[ModuleID] = @ModuleID,
	[PermissionID] = @PermissionID,
	[RoleID] = @RoleID,
	[AllowAccess] = @AllowAccess,
	[UserID] = @LastModifiedByUserID,
	[LastModifiedByUserID] = @LastModifiedByUserID,
	[LastModifiedOnDate] = getdate()
WHERE
	[ModulePermissionID] = @ModulePermissionID

GO
